USE [LAFDC]
GO
/****** Object:  Table [dbo].[Routage]    Script Date: 11/23/2009 22:56:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Routage](
	[prev_id] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[asso] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[code] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[destinataire] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[address_1] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[address_2] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ville_cp] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[quantite] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[synchrone] [bit] NULL,
 CONSTRAINT [PK_routage] PRIMARY KEY CLUSTERED 
(
	[prev_id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
